select a.EmployeeNumberID, B.AlphaName, a.employeeName, a.EmployeeSearchtype, B.searchtypeCode, B.AddressNumber, b.Category21 from 
      Star_Employee a, [RD_DWCR].[dbo].[JDEABAddressBookMaster] b
where a.EmployeeSearchTypeCode='X' and b.searchTypeCode<>'X' and a.EmployeeNumber=B.AddressNumber

/**
where EmployeeNumberID = 612391200001



select * from 
      Payroll_Star_Employee   
where AddressNumber = 6123912
**/